class BugStatusesContent < ActiveRecord::Migration
  def self.up
    query = <<-_SQL
      INSERT INTO `bug_statuses` ( `id` , `name` )
        VALUES (
        '1', 'opened'
        ), (
        '2', 'in progress'
        ), (
        '3', 'solved'
        ), (
        '4', 'closed'
        );
    _SQL
    
    execute query
  end

  def self.down
    query = <<-_SQL
      DELETE FROM `bug_statuses` WHERE `id` = 4 LIMIT 1;
      DELETE FROM `bug_statuses` WHERE `id` = 3 LIMIT 1;
      DELETE FROM `bug_statuses` WHERE `id` = 2 LIMIT 1;
      DELETE FROM `bug_statuses` WHERE `id` = 1 LIMIT 1;
    _SQL
    
    execute query
  end
end
